 |
|
|
<%set rs1=server.CreateObject("adodb.recordset")
sql="select * from class where parentid=0 order by num asc"
rs1.open sql,conn,1,1
bid=cint(request("bid"))
if not rs1.eof then
do while not rs1.eof
%>
);" class="menu" onMouseOver="this.style.backgroundColor='#00172C'"
onmouseout="this.style.backgroundColor='#F27E37'"> ·<%if rs1("child")<>0 then%>"><%=rs1("fname")%><%else%>&bid=<%=rs1("id")%>"><%=rs1("fname")%><%end if%> |
|
|
<%rs1.movenext
loop
end if%>
|
|
客服热线:
联系电话:0576-85670183
手机:13867616188
传真:0576-85696966
www.china-dingli.com
Email:A001@139.COM |
|
|
|
|
<%if request("page")="" then
page=1
else
page=cint(request("page"))
end if
if request("fenlei")<>"" then
fenlei=cint(request("fenlei"))
sql="select p.* from product p,class c where p.fenlei=c.id and p.fenlei="&fenlei &" order by p.modle asc"
else
sql="select p.* from product p,class c where p.fenlei=c.id and c.parentid="&request("bid")&" order by p.modle"
end if
' response.Write sql
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.Write("暂无产品信息!")
end if
if not rs.eof then
rs.pagesize=9
rs.absolutepage=page
end if
for i=1 to 3
if rs.eof then exit for%>
<%for j=1 to 3
if rs.eof then exit for%>
编号:<%=rs("modle")%>
名称:<%=rs("name")%>
|
<%rs.movenext
next%>
|
<%next %>
|
|
|